UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'JYQ6QVS0wLH8njzSGRXmKVkBqQ0OblpBcib7QeXDbeQ=' 
WHERE 
  key_id = '93e416a523a2978b658666e1ae766f17a4cb0c47cfbb95ae13f8c01792128b43' 
  AND (
    token = 'JYQ6QVS0wLH8njzSGRXmKVkBqQ0OblpBcib7QeXDbeQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00031