UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EV0pEB4wSKJVWvwY1qmNCd87VK6FZt2xAsqPb9G5s2w='
WHERE
key_id = 'c8adab878eab242526767e2cad2ab370ef359fcb8412de4b1b2b4b68fe001134'
AND (
token = 'EV0pEB4wSKJVWvwY1qmNCd87VK6FZt2xAsqPb9G5s2w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)