UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XfpYUuvbVWKS9lUMJGAUbQ/bjZub6gGkhGKFDJKk5WY='
WHERE
key_id = '5bd7fb38b78d54efc41a364e92a995a4735ac36e4837f7f313b7ca939ff7d120'
AND (
token = 'XfpYUuvbVWKS9lUMJGAUbQ/bjZub6gGkhGKFDJKk5WY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)