UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z7x1V1JpopV4no0TiyMij+SURHVnrFFgjPpn8JbRNJk='
WHERE
key_id = 'e04bddd1fa3e770520c5de49a841446f2bb9610eb201b4e34962d81f35d9644a'
AND (
token = 'Z7x1V1JpopV4no0TiyMij+SURHVnrFFgjPpn8JbRNJk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)