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