UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'jF0scmRKAQtcngkG9PKCXLL4zmNwLhg0lpeXAED8Pb0=' 
WHERE 
  key_id = '1c19e44d24e5e0dbe014c0cdab72a649ca0bbd3e74ad514c9133aa7932c177b0' 
  AND (
    token = 'jF0scmRKAQtcngkG9PKCXLL4zmNwLhg0lpeXAED8Pb0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00047