UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZtQHFJ7crCn/+M9BeuwM1mLcxCGaL07eo4lzxUyTUpc='
WHERE
key_id = 'c02c18138faa93d36bbff099aa9402f08d87d1058140a078fbb855fdd2aa8bed'
AND (
token = 'ZtQHFJ7crCn/+M9BeuwM1mLcxCGaL07eo4lzxUyTUpc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)