UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dFg94pfZygUwTS5OUJf77jGOVxP5JVMj5lg4pFA5U+c='
WHERE
key_id = '18678d4c6ea9562616ed7f8495794705d88d0075a885accb2401a4c5d02ce801'
AND (
token = 'dFg94pfZygUwTS5OUJf77jGOVxP5JVMj5lg4pFA5U+c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)