UPDATE 
  tmall_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'zRcSO4FcqNTDPFsWLnsRNWZXg35ExBsXxmwDe7c4qz0=' 
WHERE 
  key_id = '77458184ef96825e678a0d1c492d0f5372691e5428354b6dfbabf66a3a440aa6' 
  AND (
    token = 'zRcSO4FcqNTDPFsWLnsRNWZXg35ExBsXxmwDe7c4qz0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00779