UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'T0nSEODWcjAUeTxosq3mV95q/M2wlNgouYJdge6HPBU='
WHERE
key_id = '27c1cd6f1e6e7bc923b92583a921dee08a7f76490aebbb58c8a90b00efb8f49c'
AND (
token = 'T0nSEODWcjAUeTxosq3mV95q/M2wlNgouYJdge6HPBU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)