UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hUOE04Q5oiAHBaCNSHssZ5KcYzeEQFtAvBTUtdYtRGA='
WHERE
key_id = '7e4fb65d2b483057f7d8f3daeb3db36308459da44bb10577bc1184140eb4d6f2'
AND (
token = 'hUOE04Q5oiAHBaCNSHssZ5KcYzeEQFtAvBTUtdYtRGA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)