UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cahYWgwD2hpZ8om0GkK1St5M3MjssSIMy6X6tVquk5E='
WHERE
key_id = '662c479d2a8f9abcf329b12a9dffa708ef5e5cd7d57516ead021d31d71c3e310'
AND (
token = 'cahYWgwD2hpZ8om0GkK1St5M3MjssSIMy6X6tVquk5E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)