UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'zf3fOTF6V4kq9tOFVraAVzgRbn8uch67cCCjGnR2RPo=' 
WHERE 
  key_id = '0b85e0fe2d0b946b2f3a5d8b2f6db974629e8cdb02462f29fb37188d82b18434' 
  AND (
    token = 'zf3fOTF6V4kq9tOFVraAVzgRbn8uch67cCCjGnR2RPo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034