UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BhHDKDyUNqPla0WNP0YU36DV/7NtmTzYlop62whuzOs='
WHERE
key_id = 'c6ba6cd51663b4bc65c5542e83fae041e4502f0077afd6b2cc5d5b5a0bc2a3a4'
AND (
token = 'BhHDKDyUNqPla0WNP0YU36DV/7NtmTzYlop62whuzOs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)