UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G27cofdi0oMc7YMU4MbQlzCGXSlMUN8rFEOcXWeltdM='
WHERE
key_id = '397daa13b1adfd720fb11f4a49b80979134dea2156c305d8859f2c46d4244f18'
AND (
token = 'G27cofdi0oMc7YMU4MbQlzCGXSlMUN8rFEOcXWeltdM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)