UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J8ZYk0CZ4qMIB9z5JUfl6hYSdFttacEgtrfTK6gn4NQ='
WHERE
key_id = '8ad55fdd1aaefd39d9f36f42ef6b5e16933c553e7bab6c4a8a5f65f7ee6210ea'
AND (
token = 'J8ZYk0CZ4qMIB9z5JUfl6hYSdFttacEgtrfTK6gn4NQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)