UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lOTfia2teW0IQmA3MRcl+cSyUhfjCVMjaN+eMjKtq/M='
WHERE
key_id = 'a4d1d4e716612a68b86d78b7e3e2aaabbd2eb79d5c6f988f026433b423656999'
AND (
token = 'lOTfia2teW0IQmA3MRcl+cSyUhfjCVMjaN+eMjKtq/M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)