UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G0BVUW/5DYOEAeoxOVZ4Mn6tdgV6RrmvjyWB63h2bgU='
WHERE
key_id = 'd7fe50b3f573ac67cae70707ceb354953bb6a4b1fa666b9c1801d370b60c383f'
AND (
token = 'G0BVUW/5DYOEAeoxOVZ4Mn6tdgV6RrmvjyWB63h2bgU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)