UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZsWOG++xFxvmFU6ccEet7RMRK1DdVbkkhyWIH1852e8='
WHERE
key_id = '0a822c5582dea32a7894f4903ce1582a35103b1c43b55e4f04dc20de3914f299'
AND (
token = 'ZsWOG++xFxvmFU6ccEet7RMRK1DdVbkkhyWIH1852e8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)