UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ho1eSOLJqOFqBDHZAyEhifna+wuF39DWUmph2XXpKH8='
WHERE
key_id = '5164e42d1551f98ad8636de8729c9d50cc500ade4de742972e3595a39885340a'
AND (
token = 'Ho1eSOLJqOFqBDHZAyEhifna+wuF39DWUmph2XXpKH8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)