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