UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xlb0KhJaJ5vsCMxP/WK5/K0cyZs5aNdyYl+nvolm8Ek='
WHERE
key_id = 'e2cd68e22c6a4a8fd506515bba42b24b50d949c932196e7da9a58aa7d899f30c'
AND (
token = 'xlb0KhJaJ5vsCMxP/WK5/K0cyZs5aNdyYl+nvolm8Ek='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)