UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'M0yht3JtzsCCI1gKUEuoxftcakDmgsUCDxbe7YRxlok='
WHERE
key_id = 'ec652255653e787b7ab03d8bd0a8cf2adc1bc504bcb5341b1696f8d05eef639c'
AND (
token = 'M0yht3JtzsCCI1gKUEuoxftcakDmgsUCDxbe7YRxlok='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)