UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TXLsIotx16txnCmOBzsL+4yf8XYCtNgx3EaL/yRXshk='
WHERE
key_id = '52851842fb8126390577b3c71bf3dfafe170b4c5c7f23ec8d7ea8e7cdf200bfd'
AND (
token = 'TXLsIotx16txnCmOBzsL+4yf8XYCtNgx3EaL/yRXshk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)