UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fV9YXgZKWR7ji76DiCPtU90QVDe1OYdoJY4KD7fIYs4='
WHERE
key_id = '4d09532b7b1adac04fd67fc378cba7bb2981eae33392a35e5cf150e0313b221b'
AND (
token = 'fV9YXgZKWR7ji76DiCPtU90QVDe1OYdoJY4KD7fIYs4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)