UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '47itvrFYEu2uIWKccx8mBeirfrIu6ihkor65I6NTmxY='
WHERE
key_id = '29723cda04dfcee01431a6684dd9270105971a89ca79a3507535050d7f47f7aa'
AND (
token = '47itvrFYEu2uIWKccx8mBeirfrIu6ihkor65I6NTmxY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)