UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gcRaEfBBYvvxH8IoVFLjxqB6HnY9Xi3ZTpBycqzCBBA='
WHERE
key_id = 'e7f5763f4b4e7338e88eb6ca4559a410c32f187c363d5603562c53c396119785'
AND (
token = 'gcRaEfBBYvvxH8IoVFLjxqB6HnY9Xi3ZTpBycqzCBBA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)