UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '8QxPgxFGZrOoBTHXeF/bL0bn5+GX2Uf2TOCJFNz/vOY=' 
WHERE 
  key_id = 'd009f40dfe57b8bd0a20c0a137b6a19a1b4087da935db973ed640342c08f09cb' 
  AND (
    token = '8QxPgxFGZrOoBTHXeF/bL0bn5+GX2Uf2TOCJFNz/vOY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00038