UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2MNVRzw9CncNXK1xgA04pCMuNjUKi1JLCQHgphehz2M='
WHERE
key_id = '8cb3d157e74d159389c698704bed420c0597a2bbc40127065e1afe43afe45ae0'
AND (
token = '2MNVRzw9CncNXK1xgA04pCMuNjUKi1JLCQHgphehz2M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)