UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3hfNqkbW5ApyyAu2Z1ohkVLsvNtKZ4DH8yMYmJdCsGM='
WHERE
key_id = 'c3ab052d8e412e0c3d91e57933c063d8660da9af69f98faf0a08fa51a475a3d9'
AND (
token = '3hfNqkbW5ApyyAu2Z1ohkVLsvNtKZ4DH8yMYmJdCsGM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)