UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '5c4G9fQMVc1BPZVBujDpSE+VBQucr6xed6VKjV8E5K0=' 
WHERE 
  key_id = '98a2582133c052c01197d05affc1ade66de466506e1c0b87c1d63d6142b2e3a0' 
  AND (
    token = '5c4G9fQMVc1BPZVBujDpSE+VBQucr6xed6VKjV8E5K0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034