UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n9EbYSlO2IElERFLe9R9ji5G/2gSRwlrdwhDFmtdEZA='
WHERE
key_id = '2f9d12a9b6b9aacd78ddb60d3bb070595ed65e18779c2a9393d49cf57b2c959b'
AND (
token = 'n9EbYSlO2IElERFLe9R9ji5G/2gSRwlrdwhDFmtdEZA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)